<%@ page import="java.sql.*,studentportal.*"%>
<%
		String noteid=request.getParameter("noteid");
		System.out.println("notification id ............."+noteid);
		Connection con=MySQLDriver.getConnection(); 
		Statement st=con.createStatement();
		System.out.println("After Statement");
		String sr="select * from ADMIN_CORPORATE where notification_id='"+noteid+"'";
		System.out.println(sr);
		ResultSet rs=st.executeQuery(sr);
		if(rs.next())
		{
			String sss="insert into stu_notifi_master values('"+rs.getString(2)+"',to_date('"+rs.getDate(3)+"','yyyy-mm-dd'),to_date('"+rs.getDate(4)+"','yyyy-mm-dd'),'"+rs.getString(5)+"','STU','C')";
			System.out.println(sss);
			int i=st.executeUpdate(sss);
			System.out.println("i value is .....:: "+i);
			if(i==1)
			{
				RequestDispatcher rd=request.getRequestDispatcher("/NotificationInsertSuc.jsp");
					rd.forward(request,response);
			}
			else
			{
				RequestDispatcher rd=request.getRequestDispatcher("/AdminNotification.jsp");
				rd.forward(request,response);
			}

		}

%>